How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
Answer Posted / kishore
We can use union all Transforamtion .if the struture is
same....
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are session parameters ? How do you set them?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Describe data concatenation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to delete duplicate row using informatica?
How to differentiate between the active and passive transformations?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is rank index in rank transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Does an informatica transformation support only aggregate expressions?
Enterprise data warehouse your projects phase by phase explain?
Can we override a native sql query within informatica?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Explain sessions?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1