Answer / giri

Connected Unconnected
---------- -----------
1.With Pipe line Without Pipe line

2.Return Multiple Port Return Single Port

Answer / guest

CONNECTED T/S RECIVES MULTIPLEINPUTS AND PROVIDES MULTIPLE
OUTPUTS
SUPPORTS USERDEFINED VALUES
USE DYNAMIC CACHE
AND IF U WANT TO USE THE SAME LOOK UP MULTIPLE TIMES IN
THE MAPPING U CAN GO FOR UNCONNECTED
IT RECIEVES INPUT FROM THE RESULT OF AN EXPRESSION
TRANSFORMATION AND PROVIDES SINGLE OUTPUT
DOES NOT SUPPORT USER DEFINED VALUES
USES STATIC CACHE

Answer / siddi

conn lkp will return multiple values and supports default
values, Dynamic cache supports. Unconnected will return
single values and doesn't support default values.

Answer / jaimeen shah

1) Connected lookup receives input values directly from the
pipeline whereas Unconnected lookup Receives input values
from the result of a :LKP expression
in another transformation.

2) You can use a dynamic or static cache in connected
lookup whereas in connected lookup you can use static cache
only.

3) In connected lookup, cache includes all lookup columns
used in the mapping (that is, lookup source columns
included in the lookup condition and lookup source columns
linked as output ports to other transformations) whereas in
unconnected lookup, Cache includes all lookup/output ports
in the lookup condition and the lookup/return port.

4) Connected lookup can return multiple columns from the
same row or insert into the dynamic lookup cache whereas
Unconnected lookup designate one return port (R). Returns
one column from each row.

5) In connected lookup, if there is no match for the lookup
condition, the PowerCenter Server returns the default value
for all output ports. If you configure dynamic caching, the
PowerCenter Server inserts rows into the cache or leaves it
unchanged.
In unconnected lookup, If there is no match for the lookup
condition, the PowerCenter Server returns NULL.

6) Connected lookup pass multiple output values to another
transformation. Link lookup/output ports to another
transformation.
Unconnected lookup pass one output value to another
ransformation. The ookup/output/return port passes the alue
to the ransformation calling :LKP expression.

7) Connected lookup supports default values in the port
whereas unconnected lookup doesn't support the default
values.

Answer / pradeep

1) The connected lookup t/r connected other transformations in the pipe line and it recives input data directly from pipe line.
where as unconnected lookpup t/r not connected other t/r in the pipe line and it recive input data from the result of :LKP Expression in an other t/r,that support expressions.

2)Connected lookup support user defined functions
Unconnectd doesn't support user defined functions.

3) It returns multiple output values to other t/r
Unconnected returns single output value to other t/r.

4)Connected lookup support static and dynamic cache
Unconnected supports only static cache.

5)Connected lookup cache includes output ports in the lookup condition
Where as in unconnected lookup cache include lookup ports of lookup condition.

6)Connected lookup gives multiple output ports to other t/r.
Unconnected lookup gives single output port to other t/r.

Answer / saradhi

Connected Transformation means which is connected source to
transforamtion and target table with mappings or links.
In Unconnected Transformation there is no connection to
transformation with source and target table.

Answer / srinu

conn LKP Trans CACHE Reusable with Persistent caache
option.
Conn lkp supports Default value.

---------

UNCONN LKP Trans CACHE not reusable.
UNCONN LKP Trans Not support Default value.

Make a note of the quantity vaults made in informatica?

0 Answers  

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

What is IQD file?

1 Answers  

How to delete duplicate record in Informatica?

7 Answers  

There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.

0 Answers  

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

Why sorter is an active transformation?

0 Answers   Informatica,

What are the different types of Type2 dimension maping?

1 Answers