adspace


can we use cartesian join in informatica

Answer Posted / rajesh

yes we can ,by creating dummy ports in expression transmission like forjoin and tojoin ,in joiner transformation condition is forjoin=tojoin and output is m*n format

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain in detail about scd type 1 through mapping.

1666


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1230


How do you remove duplicate records in informatica? And how many ways are there to do it?

1253


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2845


What is dimensional table?

1188


EXL informatica Questions

1472


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1221


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2434


How to create the source and target database connections in server manager?

1161


Explain scd type 3 through mapping.

1094


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4816


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1691


Write the unconnected lookup syntax and how to return more than one column.

1185


What is dimensional table? Explain the different dimensions.

1283


draw informatica architecture 8.6 ?

3962