Interested to Buy Any Domain ? << Click Here >> for more details...
what are the output files that the informatica server creats
during running a session?
- 2 Answers
- 9201 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mithilesh kumar rai
There r 9 types of files informatica server generating.
1. BadFiles
2. Cache
3. ExtProc
4. LkpFiles
5. SessLogs
6. SrcFiles
7. Temp
8. TgtFiles
9. WorkFlowLogs
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / ravi kumar
Output Files are 11
Session Details/logs:
Workflow Log:
Performance Detail File:
Reject Files:
SessLogs
Row Error Logs:
Recovery Tables Files:
Control File:
Email:
Target or Output File:
Cache Files:
| Is This Answer Correct ? | 3 Yes | 0 No |
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
write a query to get maximum salary from the employers table without duplicates....kindly help me
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
what is the logic will you implement to load data into a fact table from n dimension tables?
What is facttable granularity?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
What is different between the data warehouse and data mart?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
What are limitations of joiner transformation?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
how to obtain performance data for individual transformations.
Teradata 
