including the ability to create “recipes,” which are sets of commands that automate tasks across different software applications based on specific triggers. The platform’s effectiveness lies in its robustAPI
Informatica PowerCenter is excellent at supporting growing data volumes of varying formats. The tool makes it easy to use metadata, reuse components across projects, and search/profile data. PowerCenter's go-to use cases are: Migration of data from on-prem systems to cloud platforms. Real-time ...
while importing the flat file, the flat file wizard helps in configuring the properties of the file so that select the numeric column and just enter the precision value and the scale. precision includes the scale for example if the number is 98888.654, enter precision as 8 and scale as 3 a...
I have oracle data source table and flat file target, now I want load data from oracle table source to flat file? How can I do? Which tranformation needs to this one? Please give solution with steps. Thanks in advance. wadate
Informatica - how to remove the null values in flat file ? import flat file from the source (with nulls) it should display without null values in the target. 10 Answers are available for this question.
UPD_DELETE (DD_DELETE)(Connect to delete group and pass only the primary key column) UPD_INSERT (DD_INSERT) NOTE: take two instances of same target.. So you have to run the mapping two times.. For this (OR) Otherwise you can use dynamic lookup in this way SRC-->SQ-->DY_LKP--...
QTP - How to load a .tsr file(object repository) in QTP thru code as it is in the Winrunner like, gui_load. Is there any script exist in QTP8.2 . 21 Answers are available for this question.
Informatica - how to join the data of two tables which does not have common columns how to join the data of two tables which do not have common columni mean how to perform non equi join in informaticaEg:just like getting data from emp and salgrade table
a) create a batch file say RunbatchJobs.batb) Open this file in notepad.c) Now,write the command "dsjob" with proper syntax for each job you want to run.d) in there are four jobs to be run in a batch,use dsjob command 4 times with different job names on each line....
Use sqlload to load the .csv file into the Oracle table. Create a sqlload control file like this: load datainfile spec_rat.csvreplaceinto table species_ratingsfields terminated by ','(species,count,rating)Invoke sqlload to read the .csv file into the new table, creating one row in the...