Interested to Buy Any Domain ? << Click Here >> for more details...
when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 11323 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 |
what is materialized view used datastage?
where we use config file as parameter ?
convert yyyy mm dd to dd mm yyyy?
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
How one source columns or rows to be loaded in to two different tables?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
What are some different alternative commands associated with "dsjob"?
What are the main features of datastage?
How do u view log file for a particular job?
Differentiate between Join, Merge and Lookup stage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Teradata 
