how we can transfer data from ms-excel, ms-access to oracle through informatica ? whether it is possible?
Latest Answer: Both are very much possiblew/ INFA: Write a mapping with src as Excel (or Access) and tgt as Oracle. Note: if your Informatica server is on UNIX, you need to save the XLS as csv and use that.w/o INFA: Using a tool like TOAD can read data from XLS ...
Similar to creating dynamic target can we create dynamic source?
Latest Answer: Can someoneplease shed some light on this? ...
Hi I'm working on XML files using them as source and target,I never worked on XML before. Did anyone worked on XML? If so could you please help me,its little bit urgent. I want to know how to import
Latest Answer: To import XML file as a source:1.To identify a source go to tools---> source analyzer2.From the sources menu option,select 'import xml file'. XML Wizard window will come.3.In the XML Wizard window the option unstructured will come.Click ...
Hi All,I want to ask about StartTask Command if i have 3 steps in the workflow and i want to ignore the first step and start workflow from step 2,so is the StartTask command will start Step2 then step3
Latest Answer: Only start step2 task. For step 2 and step 3 both do "start workflow from this task". ...
What transformation do you use to convert source column into target rows? Explain
Latest Answer: You can do it by using aggregator transformation and normalizer transformation. ...
Why Union transformation is active while it returns same number of rows as in the sources?
Latest Answer: Union Transformation is active, because you configure a session using update strategy the session property data driven instructs informatica server to use the instructions coded in mapping to flag the rows for insert, update, delete, this is the default ...
What is the main data object present in between Source and Target.
Latest Answer: Stage..where we can transform the source data and will load into TGT.Thx SRIRAM N ...
What is meant by source is changing incrementally?Explain with an example?
Latest Answer: The data in the source is not STATIC..It may change (the no. of records - addition or subtraction) over the period of time or Session run to session run....ThxSRIRAM N ...
What is the purpose of using UNIX commands in informatica?Which UNIX commands are generally used with informatica?
Latest Answer: We are using Unix in Workflow manager mainly for locating the Source / Target (Flat file) or writing script (if Server is installed in Linux) ...
Why is sorter an active transformation? What happens when you uncheck the DISTINCT option in sorter?
Latest Answer: Sorter is an active transformation since it eliminate the duplicate records when the distinct option box is checked.The uncheck distinct option will lead to show duplicate records ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
