How to display session logs based upon particular dates. If
I want to display session logs for 1 week from a particular
date how can I do it without using unix.
Answer / raju potla
Open the session properties of a session,Go to Properties
Tab then Log Option settings , in this look for Save
session log by and then select the option Session Timestamp
| Is This Answer Correct ? | 6 Yes | 0 No |
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain factlessfact table with scenario
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Briefly define reusable transformation?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
how to remove staging area
comonly how meny mappings r there in Banking projects?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
What is aggregate awareness?