HOW TO DELETE A RECORD FROM FLAT FILE

Answer Posted / subarna roy

We can write a query thru Sql transformation and delete specific records from flat file.

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the cumulative sum and moving sum?

756


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?

2428


Mention a few design and development best practices for informatica?

563


What are the measure objects?

662


Can we create multiple integration service on single repository?

701






Differentiate between a repository server and a powerhouse?

577


what is SDLC way of code development?

1559


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1623


Explian the Process of deployment groups in informatica

659


Define enterprise data warehousing?

636


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

698


Performance tuning in UNIX for informatica mappings?

2143


Differentiate between joiner and lookup transformation?

618


COM components can be used in Informatica

1875


Define pmcmd command?

623