How to load relational source into file target?
Answers were Sorted based on User's Feedback
Answer / rkumar.etl
use mapping designer create source db file as well as tgt
flat file with required column information .
While creating session provide the tgt file directory to get
the information.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / jang
It should be a direct 1-1 mapping, source having relational
table and Target a Flat file
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kammari.krishnaiah
load the data form source system to target in two ways.
one is directly storing another one is mapping (etl)in
infirmatia
| Is This Answer Correct ? | 0 Yes | 2 No |
how can u approach u r client
Without using Lookup & Sequence Generator, How to generate Sequence?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
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. ?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
Can you generate sequence numbers without using the sequence generator transformation?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,