Please help to set up following scenarioi have a source EIther file or db tableeno ename sal dept101 sri 100 1102 seeta 200 2103 lax 300 3104 ravam 76 1105 soorp 120 2want to run a session 3 times.First time: it should populate dept 1second time: dept 2 onlythird time: dept 3 onlyhow can we do...
Can we update target table without using update strategy transformation?
Yes, By using session level properties. In that use follow the steps Session --> Edit --> Properties --> Treat source rows as --> Update and also you should check options in Mapping --> Target --> U...
yes we can , it is the just that update strategy is used for conditional updates, and the update option available at the mapping level in the target is update without any condition.
Can we use aggregator/active transformation after update strategy transformation
We can but the results may change what you are expecting in output
what will be if the flag will be Insert and SUM in the agggregator T/R?
How to read the data from XML and flat files in Informatica?
From flat file you use the following wys: --> In source analyzer you can create file by manually -->you can import file -->you can use any of the flat file and give session properties in that correc...
Go to Source analyzer , then import XML Source, a wizard opens up.. select the Schema Definition (XSD) of th XML file
When you run the session, give the XML file name and XML file directory path.
What is staging are why we need it
It is a automated process of building a data warehouse which involves taking the data from disparate source systems, converting them into a consistent form that can be loaded into the warehouse and pe...
Can we update target table without using update strategy transformation? Why?
Step 1: Go to session , and in treat source rows as :UPDATE
step2: in target table option select INSERT and UPDATE ELSE INSERT :)
Step 3:Refresh and Run the session .
By using source qualifier transformation to update tha target table,through SQL overriding...
In which condtions we can not use joiner transformation(limitaions of joiner transformation)?
Both pipelines begin with the same original data source. Both input pipelines originate from the same source qualifier transformation. Both input pipelines originate from the same normalizer transformation. Both input pipelines originate from the same joiner transformation. EIther input pipelines contains...
Why Joiner transformation cannot be used when either of the input pipeline contains an Update Strategy transformation.
We cannot use joiner transformation in the following two conditions:-1. When our data comes through Update Strategy transformation, or in other words after Update strategy we cannot add joiner transfo...
service oriented Architecture,Pushdown Optimization,sql t/r is added,java t/r is add
main difference between informatica 7.x and 8.x are:-
1. Java transformation is introduced in Informatica 8.x. while was not in 7.x
2.and Power exchange tool also introduced in informatica 8.x while was not in 7.x
Structure of the reject file in Informatica
What is the structure of the reject file in Informatica?
we need to give the option in target level for rejected data (means needs to give the path of the badfiles to capture the rejected data)
There is no predefined structure for bad files. It has the same structure as of the target table.
If you have four lookup tables in the workflow. How do you troubleshoot to improve performance?
If the lookup source is same for all the lookups and if we are returning different columns for calculations then it is better to use unconnected lookup with expression instead of using connected lookup.
1) Create Indexes on look up tables.
2) Try to use static cache instead of Dynamic cache.
3) Use Pushdown Optimization.
by using BELOW SCENARIO we can do it the flow is like this
SRC-->SQ-->EXP-->T1
T2
Hi Shiva,
You can use Normalizer t/f to achieve the desired output. There is an "Occur" option in Normalizer in which you can mention the no of times you want to load the same source data into target.
Why sorter transformation is an active transformation?
Actually Sorter acts as both passive/Active if we check the Distinct Property then it acts as Active othewrwise passive
The Sorter transformation is an Active transformation because its attribute, Distinct provides a facility to remove duplicates from the input rows.
How to load data from Oracle table source to flat file using Informatica?
Hi all, 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.
source--->sqt/r--->Target
In session level(advanced file properties) u have to set some of the properties like output type,directory, filename and codepage type.
How we can validate all mapping at a time?
We can validate all mappings in powercenter repository manager window by each folder.
in repository go to menu tool then queries.query browser dialog box will appear.then click on new button. in query editor,choose folder name and object type after that execute it(by clicking the blue...
If the records are transfered from source to target and if you want to check whether all the records are stored in the target. What are the possible ways to check that.
If you want to check the records,you can directly use MINUS query for eg
Hope this will help Thanks RishaCode
SELECT count(*) FROM source minus SELECT count(*) FROM target
1) Check Session Logs
2) Use Preview Data option for Target in PowerCenter once session is completed
3) Sql queries if it is a Relational database
How can we load date type of data in month wise in Informatica?
TO_CHAR(DATE,MM) or
TO_CHAR(DATE,MON) or
TO_CHAR(DATE,FMMONTH)
ex :to_char(trunc(sysdate),mm)
to_char(date,mm)
How do you handle error logic in Informatica? What are the transformations that you used while handling errors? How did you reload those error records in target?
So we create 2 variable for every field on which we have to do error logging. 1 variable will check the condition for error (i.e. check for isnull or check for datatype) and assign NULL if it does not...
It is one of the most common concept which is being implement in alomost all DW projects. A very simple way of handing error and with their approprite messages is:Concat all the columns with a delimet...
How to connect in mapping from target to any other transformation in Informatica ?
I have two target tables,so I want to make union of both the target,so please let me know about this
Make two flows in the same mapping:
flow 1: load both the targets
flow 2: use both the targets as the source and use SQL override to join the tables. Then load them into a single table
I think your question is how to merge the records from two targets after they got loaded? If this is your question then first import the two target tables as source tables. Complete the mapping to loa...
How to solve pcsf_10342 when enabling integration service in Informatica 8.6.1 ?
Login to the admin console and delete the repository content and recreate it. Restart the integration service. It works!
What is redo log file in Informatica ?.
There is no redo log file in informatica.Its in oracle.
Redo log file stores the value only after the" Commit "Transaction Occurs
We can solve this issue by the following types: First, we can create a mapping parameter and run the mapping in each time give the parameter value according to your requirement. Second, we can creat...
Put this query in Source Qualifier select empno, ename, sal, deptno from emp_src where deptno not in (select deptno from emp_trg); Then connect it to Rank Transformation In the properties, Select To...