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
Where are the source flat files kept before running the session?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
how many types of dimensions are available in informatica?
What is deployment group?
Is it possible to define a single node as a Gateway node as well as worker node?
Define pmcmd command?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain the etl program with few examples.
How many input parameters can exist in an unconnected lookup?
What is data transformation manager process?
Explain the difference between a data warehouse and a data mart?
Sequence generator, when you move from develoment to production how will you reset
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?