Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Differences between connected and unconnected
lookup?
- 6 Answers
- 21100 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / mayur
Connected Lookup
- In mapping flow (Pipeline)
- One or more output (Multiple return port)
- Can Assigned Default Value
- Have to create new if more than one table to lookup in the same mapping
Unconnected Lookup
- Not in mapping flow
- Only one output (Single return port)
- Can’t assign default value
- Can use multiple time
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is a shortcut and copy in Informatica and how two are different with each other?
pmscmd startworkflow -sv
What is the function of union transformation?
How can we improve session performance in aggregator transformation?
Different circumstance which drives informatica server to expel records?
What is meant by incremental aggregation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is the size of u r source(like file or table)?
How to generate sequence numbers using expression transformation?
What is primary and backup node?
