i have 1000 record flat file source i want 1st row to 1st
target, 2nd row to 2nd target, 3rd row to 3rd target how will
u do? Without using Mod Function? Explain....
Answer Posted / ramakrishna
simple before targets put the sequence generator t/f enable cycle option put start value 1 and end vale 3 connect to all three target
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do we call shell scripts from informatica?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Explain dynamic target flat file name generation in informatica
What are the databases that informatica can connect to windows?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How identifying bottlenecks in various components of informatica and resolving them?
Why update strategy and union transformations are active?
How to join three sources using joiner? Explain though mapping flow.
Define joiner transformation?
What is a standalone command task?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the differences between oltp and olap?
Which transformation is needed while using the Cobol sources as source definitions?
How do you change a non-reusable transformation to reusable transformation?
What do you mean by channel change?