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 / arjun
not possible
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
COM components can be used in Informatica
What the difference is between a database, a data warehouse and a data mart?
Explain how to import oracle sequence into informatica?
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?
How to join three sources using joiner?
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,
What is primary and backup node?
What is a router transformation?
Differences between version 7.x and 8.x.
can you please explain me pre session and post session options?
What is the use of source qualifier?
Can you use flat files in Mapplets.
Explain about Informatica server process that how it works relates to mapping variables?
What is informatica?