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 / arvind s
Sorry guys, Answer 3 is completely wrong.
TRUE is not identified as a string by informatica, its
represented as a bit, just like a high or low, (1 or 0)
almost equivalent to a boolean.
So we can equate sal=TRUE but sal='TRUE' will result in
invalid mapping as said in answer3.
Thanks,
Arvind S
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Define sessions in informatica etl?
can u any challenge your project?
According to his methodology what all you need before you build a datawarehouse
What is main use of mapplet?
Explain the types of lookup transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain about cumulative Sum or moving sum?
What is aggregator transformation in informatica?
COM components can be used in Informatica
What are the advantages of using informatica as an etl tool over teradata?
What is meant by incremental aggregation?
Differences between connected and unconnected lookup?
How does a sorter cache works?
What do you mean by filter transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.