Interested to Buy Any Domain ? << Click Here >> for more details...
What is the main purpose of Unconnected lookup other than
updating slowly changing dimensions?
or In which case u use Unconnected lookup?
- 2 Answers
- 7421 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ratalarayudu
hi,
The main purpose of unconnected lookup t/r is
1.To update slowly changing dimensions
2.if we want to use the same lookup multiple times in a
mapping we can go for unconnected lookup
3.if we want to lookup on only selected rows then we can go
for unconnected look up.
regards,
rayudu.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / praveenabhaskar
We can use unconnected lookup transformation when we have
multiple inputs and single output.
| Is This Answer Correct ? | 3 Yes | 2 No |
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to create the source and target database connections in server manager?
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
Which gives the more performance when compare to fixed width and delimited file ? and why?
What are the types of caches in lookup? Explain them.
my source is junk data how will u remove that junk data by using unix please any one replay me
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
Teradata 
