how to design mapping half of source table records into one
target and remaining half into another target
Answer Posted / sbvp
hi raj
when we use source as a flat file
if a flat file contians 10 records assume ok
take seq gen t/r- next val
to exp t/r
in that add a new port and give seq gen-nextval to that new
port(suppose call as seq_num ok)
take RTR t/r
create two out ports ok
seq_num<=5
seq_num>=5
contect to two tgrts ok
thanks
sbvp
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to generate sequence numbers?
What is the difference between a connected look up and unconnected lookup?
Explain dynamic target flat file name generation in informatica
Which development components of informatica have the highest usage?
Whats there in global repository
How many input parameters can exist in an unconnected lookup?
What are active transformations.
What is workflow monitor?
What are the main features of Oracle 8i with context to datawarehouse?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to extract sap data using informatica? What is abap? What are idocs?
How are the sources and targets definitions imported in informatica designer?
difference between repository database and repository service?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is the format of informatica objects in a repository?