While importing the relational source defintion from
database,what are the meta data of source U import?
Answer / swetha
Source name
Database location
Column names
Datatypes
Key constraints
Is This Answer Correct ? | 6 Yes | 1 No |
HOW DO YOU CONNECT TO REMOTE SERVER ?
update strategy transformation in informatica
how we can update a target table without update strategy and update override?
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
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?
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
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..
What does “tail –f” command do and what is its use as an Informatica admin.
What is source qualifier transformation in informatica?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
How to update a particular record in target with out running whole workflow?
Whats the difference between informatica powercenter server, repositoryserver and repository?