Tuesday, June 10, 2014

No Log Found error in OBIEE 11g:-











Setting Log Level in RPD:
We have to check the Logging Level in three places in RPD.
Step 1 : Open RPD by using the credentials.
Step 2 : Go to Tools–>Options–>Repository
Here set the Log Level to 7 in System Logging Level.

 


Step 4 : Sometimes we used to define the Log Level in Initialization Blocks.
Go to Variables–>Session–>Initialization Blocks–Log Level.
Edit the Data Target and set the Log Level to 7.

Lot of time we saw everything is good and same manner but same error No Log Found  again and again
After that we need to check  --
Go to em
Capacity
And change the Number of rows:-




Monday, April 28, 2014

What is DTM session?



What is DTM session?
 DTM - Stands for Data Transformation Manager. This is a unix process /windows service which runs on Informatica server and does the actual processing of the ETL code.

Thursday, April 24, 2014

PMCMD Command

PMCMD Command

1. Scheduling a workflow 
pmcmd command syntax for scheduling the workflow is shown below: 
pmcmd scheduleworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name

This command just schedules the workflow for the next run. 

2. Start workflow 
The following pmcmd command starts the specified workflow: 
pmcmd startworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name

This triggers the work-flow immediately

3. Stop workflow 
Pmcmd command to stop the infromatica workflow is shown below: 
pmcmd stopworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name

4. Start workflow from a task 
You can start the workflow from a specified task using the following syntax: 
pmcmd startask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name -startfrom task-name


5. Stopping a task. 
The following pmcmd command stops the specified task instance: 
pmcmd stoptask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name task-name


6. Aborting workflow 
The following pmcmd commands are used to abort workflow: 
pmcmd abortworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name


7. Aboting specific task
The following pmcmd commands are used to abort a specific task in a workflow: 
pmcmd aborttask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name task-name

Data engineering Interview Questions

1)  What all challenges you have faced and how did you overcome from it? Ans:- Challenges Faced and Overcome As a hypothetical Spark develop...