Interested to Buy Any Domain ? << Click Here >> for more details...
when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 11479 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 |
How to reverse the string using unix?
Different ways a project can be moved to production ?...example ….export-import and Version control.
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
Where the datastage stored his repository?
what is a force compile
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
how to create document in datastage?
What is the project in datastage?
What are the functionalities of link collector?
can we half project in parallel jobs and half project in server jobs?
root tree will find which is server job and which is parallel job?
Teradata 
