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


Please Help Members By Posting Answers For Below Questions

What differs when we choose the sorted input for aggregator transformation?

669


Does an informatica transformation support only aggregate expressions?

699


Can we change Dynamic to Static or Persistent cache? If so what happens?

1811


Why is sorter an active transformation?

759


How we can use union transformation?

696






Sequence generator, when you move from develoment to production how will you reset

1526


Why union transformation is an active transformation?

751


Enlist the differences between database and data warehouse.

639


What does command task mean?

696


What is joiner transformation in informatica?

714


What is the function of aggregator transformation?

667


According to his methodology what all you need before you build a datawarehouse

1290


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

1618


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?

2502


Explain incremental aggregation in informatica

746