-
-
Informatica: if flat file name varies day by day ...
If we are using flat file in our loading, and flat file name change daily so how we handle this without changing file name manually daily? for example: like file name is changing depend on date so what should I do? pls help…
-
-
Error handling Logic
How do you handle error logic in Informatica? What are the transformations that you used while handling errors? How did you reload those error records in target?
-
Source as Txt Files
How do you handle the changing no of files as source in the mapping/session which loads the data in a Relational table
-
-
-
What is tracing level and what are the types of tracing level?
Tracing level represents the amount of information that informatcia server writes in a log file. Types of tracing level Normal Verbose Verbose init Verbose data
-
In which circumstances that informatica server creates Reject files?
When it encounters the DD_Reject in update strategy transformation. Violates database constraint Filed in the rows was truncated or overflowed.
-
What r the data movement modes in informatcia?
Datamovement modes determines how informatcia server handles the charector data.U choose the datamovement in the informatica server configuration settings.Two types of datamovement modes avialable in informatica. ASCII mode Uni code mode.
-
What is the default join that source qualifier provides?
Inner equi join.
-
What are the types of data that passes between informatica server and stored procedure?
3 types of data Input/Out put parameters Return Values Status code.
-
What r the designer tools for creating tranformations?
Mapping designer Tansformation developer Mapplet designer
-
How many ways you can update a relational source definition ?
Two ways 1. Edit the definition 2. Reimport the defintion
-