what is lookup ?6 5013
what is the flow?1 2323
In update strategy target table or flat file which gives more performance ? why?7 12110
Why touse stored procedure in ETL Application?2 5530
What is critical mapping?1 4703
How to view and Generate Metadata Reports?1 2937
what is the gap analysis?1 4660
How to recover sessions in concurrent batches?3 8108
what are the different types of transformation available in informatica and what are the mostly used ?
Is there any target staging area in informatica not staging area
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id firstname.lastname@example.org
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are the modules in Power Center
In which scenario did you used pushdown optimization?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
what is the size of u r source(like file or table)?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
What are the main features of Oracle 8i with context to datawarehouse?
have u done any performance tuning? how u ll do?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?