ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO
CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF
RUNNING ?
Answer Posted / divi
I think we can change it in session properties of mapping
tab.if select flatfile on top of that we see set file
properties.
Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What differs when we choose the sorted input for aggregator transformation?
Does an informatica transformation support only aggregate expressions?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Why is sorter an active transformation?
How we can use union transformation?
Sequence generator, when you move from develoment to production how will you reset
Why union transformation is an active transformation?
Enlist the differences between database and data warehouse.
What does command task mean?
What is joiner transformation in informatica?
What is the function of aggregator transformation?
According to his methodology what all you need before you build a datawarehouse
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Explain incremental aggregation in informatica