What is the benefit of session partitioning?
No Answer is Posted For this Question
Be the First to Post Answer
Explain pushdown optimization and types in informatica
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
what is procedure to use mapping variable in source qualifier transformation? with example
What are the unsupported repository objects for a mapplet?
Explian the connected and unconnected lookup transformation
what is plsql table?
How to extract original records at one target & Duplicate records at one target?
What is difference between partioning of relatonal target and partitioning of file targets?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
What are the challenges of Dataware housing in the future?