If I have router with 10 records, if the condition doesn’t
satisfy the records will pass to the default group,then
where can we see that records and where that records will store?
Answers were Sorted based on User's Feedback
Answer / sravan
If you want to see those records, u have to connect default
group to some other target table. I think, this is the
only way, we can see those records.
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / gsr
All the rows which do not meet any of the conditions are
passed to the default group. If we dont need the rows in
the default group we can drop them by not connecting them
to another transformation or a target in the mapping. If we
need them we can connect them to another transformation or
a target in the mapping.
Is This Answer Correct ? | 1 Yes | 1 No |
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
What is Datadriven?
How/where can i install Informatica software with oracle or teradata as database
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
normalizer transformation
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
can a port in expression transf be given the name DISTINCT
How you can differentiate between connected lookup and unconnected lookup?
Design a mapping to load a target table with the following values from the above source?
What are the types of metadata that stores in repository?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....