While importing the relational source defintion from
database,what are the meta data of source U import?



While importing the relational source defintion from database,what are the meta data of source U im..

Answer / swetha

Source name

Database location

Column names

Datatypes

Key constraints

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More Informatica Interview Questions

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,


update strategy transformation in informatica

0 Answers   Informatica,


how we can update a target table without update strategy and update override?

3 Answers   TCS,


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  


I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,






I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,


Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,


What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  


What is source qualifier transformation in informatica?

0 Answers  


two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,


How to update a particular record in target with out running whole workflow?

0 Answers  


Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  


Categories