for ex: in source 10 records are there with column sal. use
a filter transformation condition as Sal=TRUE and connect
to target. what will happen.
Answer Posted / venkat
hi guys ans 3 totally wrong
see this,
1)suppose u given condition like sal=true ,the session will
successfully execute but no data load in to target.
2)suppose u given condition like sal='true' it's not
validated b'coz in filter true/false like 1/0.
3)suppose u given condition like onlt true ,the session will
successfully execute and all the data also loaded in to target.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a dimensional model?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Under what condition selecting sorted input in aggregator may fail the session?
What do you mean by filter transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is informatica powercenter repository?
Briefly describe lookup transformation?
What are the uses of etl tools?
How many number of sessions can one group in batches?
What is joiner transformation in informatica?
How can we create index after completion of load process?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
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
Explain constraint based loading in informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you