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 |
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
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?
how we can load rejected record's at run time?(not through bad files)
what is parameter file?
Explain incremental aggregation in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
wht is cdc?how to use it in creation of mappings?
how the server recognises , if the session fails after loading the 100 records in to the target
What is deployemnt groups, Lables, query and dynamic deployment group.
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
Explain informatica architecture - version 8 / 9