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 / rahul
no its not possible.
sql trans is used to connect hetro src but when you drag
flat file n connect to Sq t/r , all properties expect
tracing level evey thing will be disable.
SO WE CANT JOIN
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Design a mapping to load a target table with the following values from the above source?
What is rank transformation?
Can we create a Integration service without a Repository service and vice versa?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
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,
Explain the different lookup methods used in informatica?
Explain the types of lookup transformation?
What do you understand by term role-playing dimension?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Differences between version 7.x and 8.x.
What is olap (on-line analytical processing?
What is workflow? What are the components of workflow manager?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks