How to load data into 3 target tables which are in
different schema but with the same name and same relational
connection at infromatica level ?
How to differentiate while loading ? and how to load ?
- 2 Answers
- 9079 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / robin
use scheman name as prefix in the table name in session
properties.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kritika
in the session we can give different connections based upon the database we want to load. In each table there will be different connection where we can give different database name
| Is This Answer Correct ? | 5 Yes | 1 No |
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are two types of processes that informatica runs the session?
star and snowflake schema?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Briefly explain the aggregator transformation?
How can you join two tables without any common column present in them?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
server hot-ws270 is connect to Repository B. What does it mean?
How to delete the data in the target table after loaded.
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
Teradata 
