Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
- 2 Answers
- 7508 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bidhar
First thing to note is that Both the sources must be
Homogeneous.
Also the Order of the ports in SQ and the order of the
Columns in the select query (if you are using SQL override)
must be same.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / krishna
1.two or more relational tables are with primary key-
foreign key relationships by linking the sources to one
Source Qualifier transformation.
2.the data types of the ports must match.
violation of these two conditions may lead to errors while
joining two tables
| Is This Answer Correct ? | 1 Yes | 1 No |
explain about session partitions ?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
What is a code page?
waht type of interface is used for testing the data in informatica
Two different admin users created for repository are ______ and_______
What is meant by active and passive transformation?
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
Why is sorter an active transformation?
how can u load the data in time dimension?
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
Teradata 
