in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ?
- 9 Answers
- 18675 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / vishnu_kr
HI, UZVAL
PLEASE STATE HOW DO U USE UNCONNECTED LOOKUP FROM A SOURCE
QUALIFIER
IN MY KNOWLEDGE WE CAN'T USE U/C LKP IN SQ BUT WE CAN USE
IT IN OTHER TRFNs LIKE ROUTER, AGGR ETC.. WHERE EXPRESSIONS
EVALUATION IS ALLOWED.
PLEASE REPLY IF I AM WRONG.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is meant by active and passive transformation?
What are the tasks that can be performed using sq?
How do you load unique records into one target table and duplicate records into a different target table?
Briefly describe lookup transformation?
scenario where i can use only concurrent execution of workflow.
What is option by which we can run all the sessions in a batch simultaneously?
Informatica Checkpoints
What are some examples of informatica etl programs?
What is meant by incremental aggregation?
What is a repository manager?
Which transformation is needed while using the Cobol sources as source definitions?
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?
How many ways a relational source definition can be updated and what are they?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
