Tell me about your experience in informatica? what is best
mark you can give yourself? How to answer this question?
No Answer is Posted For this Question
Be the First to Post Answer
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
What is joiner transformation in informatica?
What r the type of indexes u generally used in informatica?
What are the join types in joiner transformation?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is rank transformation in informatica
How/where can i install Informatica software with oracle or teradata as database
Under what condition selecting sorted input in aggregator may fail the session?
What is the format of informatica objects in a repository?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
Which kind of index is preferred in DWH?