Interested to Buy Any Domain ? << Click Here >> for more details...
when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 11138 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
This Questions Related for Informatica not in Datastage.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / jayanthi
In Datastage, the same can be expalained as Normal
(Connected)Lookup and Sparse(unconnected) lookup.
For sparse lookup
When the refrence data volume is huge and primary volume is
very less,you can pass the input records key columns to
match against reference in refrence table extraction query
where clause.
| Is This Answer Correct ? | 3 Yes | 1 No |
i have flat file and using unix how can i generate sequence number into targer?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the primary usages of datastage tool?
Define Data Stage?
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
what is the function in Transformer stage can act as Rank function in Oracle
Which warehouse using in your datawarehouse
what is the Difference Between Datastage Server Edition and Parallel Edition?
How to enter a log in auditing table whenever a job get finished?
What is mapping?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
Teradata 
