Can you access a repository created in previous version of Informatica?
Answer / ratna
Yes it's possible but we need to upgrade the repository from old version to new version.
Is This Answer Correct ? | 0 Yes | 0 No |
what is pre and post sql and what is diff between source presql and target pre sql
What is mapplet and a reusable transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
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?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
How to recover the standalone session?
Mention a few design and development best practices for informatica?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
What are the components of Informatica? And what is the purpose of each?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
What is informatica worklet?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?