If we use sorted ports in aggregator transformation
and somehow records are not in order by format so what
will happen,session fails or it succeeded with incorrect data?
Answer / akhil4
session will be failed,when ever u enable the sort ports option u can use "sorter transformation" before "aggregator trns" that time session will be run.
| Is This Answer Correct ? | 5 Yes | 1 No |
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
In which transformation you cannot drag ports into it?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
What is a passive transformation?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
What are the data movement modes in informatcia?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
what is the Default Source Option For Update Strategy Transformation?