Skip to main content

Posts

Load the session statistics such as Session Start & End Time, Success Rows, Failed Rows and Rejected Rows etc. into a database table for audit/log purpose.

                                                                                                                                                                     ...

Use Target File Path in Parameter File

                                                                                                                                                                     ...

Insert and reject records using update strategy.

                                                                                                                                                                     ...

Convert Numeric Value to Date Format

                                                                                                                                                                     ...

How to change a string to decimal with 2 decimal places in informatica?

                                                                                                                                                                     ...

Append the data in a flat file for a daily run

                                                                                                                                                                     ...

How to delete duplicate rows in a table?

                                                                                                                                                                     ...

How to get nth max salaries ?

                                                                                                                                                                     ...

How to get 3 Max & Min salaries?

                                                                                                                                                                     ...

Find FIRST & LAST n records from a table.

                                                                                                                                                                     ...

Find the 3rd MAX & MIN salary in the emp table

                                                                                                                                                                     ...

Complex Queries in SQL ( Oracle )

                                                                                                                                                                     ...

Informatica Quiz: Set 2

                                                                                                                                                                     ...

Informatica Quiz: Set 1

                                                                                                                                                                    ...

How large is the database,used and free space?

                                                                                                                                                                     ...