Answer Posted / somu
i think
if you want to text the records from one table
that time you can go to session properties and select text
load option and give number like how many rows you want to
test(ex: 10)
after completion of the session you cant able to see the
tested records in your target table
you would get o/p like: no rows should be selected
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain sql transformation in script mode examples in informatica
tell me about your project functionality
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Why is sorter an active transformation?
Define mapplet?
What is the benefit of partitioning a session?
What is the need of an ETL tool?
How to start a workflow using pmcmd command?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
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
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Suppose we do not group by on any ports of the aggregator what will be the output?
What is standalone command task?
What are the different components of powercenter?
What are the mapping parameters and mapping variables?