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 / krishna
I checked result.
Case 1: when you use filter condition sal=true
nothing will be moved to target table. session succeeded
but no data in target table.
Case 2: when you use only TRUE as filter condition.
all 10 records from source passes through filter to target
table .(in target table also we will get 10 records)
| Is This Answer Correct ? | 31 Yes | 0 No |
Post New Answer View All Answers
Can anyone tell me the new features in Informatica 9 Version?
How can you generate reports in informatica?
Differences between version 7.x and 8.x.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are some examples of informatica etl programs?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Where is metadata stored?
How to open an older version of an object in the workspace?
How do you update the records with or without using update strategy?
how many types of dimensions are available in informatica?
How can you validate all mappings in the repository simultaneously?
What does refresh system mean, and what are its distinctive choice?
What is meant by pre and post session shell command?
Enlist the advantages of informatica.
How to load the data from people soft hrm to people soft erm using informatica?