Answer Posted / santhosh kumar n
yes we can partitioning,but we can,t splits fact tables
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Design a mapping to load a target table with the following values from the above source?
How to update a particular record in target with out running whole workflow?
What is the use of code page?
Informatica Checkpoints
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain your project of banking domian.
Explain lookup transformation source types in informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Please let me know how to make encryption and decryption with example?
Under what condition selecting sorted input in aggregator may fail the session?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
what is unit testing?tell me proceedure
Where is metadata stored?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?