Answer / harry

When we want to get single return value, and also we can
call this anywhere in the mapping

Answer / pooja ahmed

1. When we want to get single return value
2. also we can call this anywhere in the mapping
3. when no.of recs are less go for unconn lkp, which improv
t\da performacesa

Answer / arvind

When we want to get single return value, and also we can
call this anywhere in the mapping
In addition to this it gives u the flexibility to run
lookup for selected source rows which u dont find in
connected lookup

Answer / guduri hari

When we want to get single return value,we can call this
anywhere in the mapping...
> when no.of recs are less go for unconn lkp, which improve
the performancee
unconnect give performance edg

Answer / suneel reddy

Answers 1:
Depending upon the scenario we use the conn and unconn tr..

for e.g
In u r mapping u require same lkp multiple times, creating
lkp multiple times put it in flow is not a good idea, which
occupies more cache ...
Instead of that create one unconnectes lkp use multiple
times where ever u want , which very fast..

Answers 2:
u can use conn lookup but if u need 1 row so go for unconn
lookup coz u can
use it multiple time in same mapping from multiple
expression trn.
i hope it will help to u

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  

Define Update Override?

1 Answers  

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

What is a sorter transformation?

0 Answers   Informatica,

All active transformations r passive or not?

7 Answers  

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,