Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 11 Answers
- 23087 Views
- Accenture, I also Faced
- E-Mail Answers
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
Is it possible to create multiple domains on a single Informatica server?
What is primary and backup node?
How do you load alternate records into different tables through mapping flow?
How do you update the records with or without using update strategy?
Enlist some properties of sessions.
Which transformation should we use to normalise the COBOL and relational sources?
What could be the possible resons of locks by user?
Why filter transformation is an active one?
How do you take back up of repository?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the static cache and dynamic cache in informatica?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is update strategy transform?
What is meant by lookup transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
