hOW TO LOAD SOURCE INTO TARGET 2 TIMES?(INFORMATICA)
Answer Posted / balakrishna
use normalizer transformation. In the occurs column change to 2 times for each column
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between delete and truncate table?
How many types of normalization? What is the use of it?
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
What is a sequence? Explain it with one example?
how can you perform lookup range in lookup stage expalin in detail?
Under which circumstance should you create an index on a table?
What are different types of blocks used in stored procedure?
What is the function of cluster index?
Is hive a database?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
How to do Data integrity testing? Who does this testing (Developer or tester)?
Which database does facebook use?
Explain storage manager?
What is the advantage of varchar2 over char?
What the various ways to tune a teradata query