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
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the status code in stored procedure transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is different between the data warehouse and data mart?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is decode in informatica?
Differentiate between sessions and batches?
Enlist few areas or real-time situations where informatica is required.
Enterprise data warehouse your projects phase by phase explain?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Make a note of the quantity vaults made in informatica?
How identifying bottlenecks in various components of informatica and resolving them?