1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
Answer Posted / anas furquan
Use Filter transformation with below condition:
IIF(FIELD!='*',1,0)
Mapping:
Source-->SQ-->Filter-->Target
This works. :)
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Differentiate between router and filter transformation?
what is size of u r database?
What does command task mean?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How do you change a non-reusable transformation to reusable transformation?
What are the guidelines to be followed while using union transformation?
What is flashback table ? Advance thanks
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain sql transformation in script mode examples in informatica
What does role playing dimension mean?
What is informatica metadata and where is it stored?
What is the use of an aggregator cache file?
What are the designer tools for creating transformations?