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 / amit
it gives expression error because we used sal=true
expresssion insted of sal='any numeric value i.e. we have
to define numeric value in the expression
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
how tokens will generate?
What is deployment group?
design of staging area?
What is meant by query override?
Difference between Data and Index Caches?
Informatica settings are available in which file?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain the features of connected and unconnected lookup.
What is joiner transformation?
Define joiner transformation?
Design time, run time. If you don't create parameter what will happen
What are the limitations of joiner transformation?
What is a repository? And how to add it in an informatica client?
How do you load only null records into target? Explain through mapping flow.
What is informatica etl tool?