[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.

Technical Interview Questions and Answers :: Informatica

    11 / 94

    Without using any transaction how to find whether there are duplicates in the target.(I don’t want to use any sql and filter or select distinct option)
    Answer:

    No Discussion on this question yet!

    Please Login First :

    12 / 94

    Tables are updated every 4 hours. So suppose the last update failed then how to retrieve data for the total of 8 hours, the current 4 hours and the last 4 hours that failed.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    13 / 94

    Have you used parameter files. which parameter is used to save session logs.
    Answer:

    For

    Please Login First :

    14 / 94

    Without having to go to informatica, can we check session log from unix(vi editor). are the logs in text format that we can read them.
    Answer:

    in session properties there is an option to create backend compatible log .

    Please Login First :

    15 / 94

    Difference in event wait task and event raise task.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    16 / 94

    Have you used any task.(why is email task used. can we use email task to send the logs)
    Answer:

    No Discussion on this question yet!

    Please Login First :

    17 / 94

    How did you do unit testing. Can we check from informatica itself whether the rows are correctly updated.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    18 / 94

    Your team size is so big. how many sources did you have.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    19 / 94

    How many workflows were there in the project(1000+ or less than 1000)
    Answer:

    No Discussion on this question yet!

    Please Login First :

    20 / 94

    I want to select first 1000 characters from a column. which function should I use. (LEFT function or ltrim, rtrim): select LEFT (col_name, 1000) from table_name; select LEFT (col_name, LEN(col_name)-(no_of_char_to_trim)) from table_name;
    Answer:

    select left(column_name,100) from tablename;

    Please Login First :