Interested to Buy Any Domain ? << Click Here >> for more details...
two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
- 10 Answers
- 25313 Views
- HP, Patni, I also Faced
- E-Mail Answers
Answer Posted / srinivas chowdary
If the Tables from two different datbases we should go with
Joiner Transformation.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
How can we remove the duplicates from flat file source?
How to differentiate between the active and passive transformations?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the cumulative sum and moving sum?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
explain abt ur project architecture?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is rank transform?
What is a sorter transformation?
Which files are created during the session rums by informatics server?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is parallel processing in informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain why we use partitioning the session in informatica?
