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 / mack
Answer 3 is correct. Whenever you trying to validate your
expression ,it will give you an error.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What are different types of transformations available in informatica?
Explain your project of banking domian.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Global and Local shortcuts. Advantages.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How can we use mapping variables in informatica? Where do we use them?
How will the document be delivered to me?
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.
What are the differences between source qualifier and joiner transformation?
What is the cumulative sum and moving sum?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are connected or unconnected transformations?
What is meant by a domain?