Rajarao marisa

• May 31st, 2012

Ok its not good work environment by using multiple filter t/r usage Any way by using multiple filter we can load rejected rows also SD-->SQ-->fltr(condition(true)(eg:deptno=10)---->loaded into one tar...

srinuraj

 Profile Answers by srinuraj Questions by srinuraj

• May 31st, 2010

You can use filter transformations to filter rows. Filter transformations passes rows to next transformation which rows met the condition. But it cannot pass rows which rows doesn't meet the condition...

Answer Question  Select Best Answer

Is it possible that a Star Schema contains more than one fact tables? If Yes, How?

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Jun 21st, 2012

Yes we can logical fact in terms of obiee in star scema
and also with then help of Confirmed dimension we can have another fact in starschema

Rajesh

• Aug 1st, 2011

NO

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Jun 21st, 2012

Actually Sorter acts as both passive/Active if we check the Distinct Property then it acts as Active othewrwise passive

vishalkrishan

• Jun 19th, 2012

The Sorter transformation is an Active transformation because its attribute, Distinct provides a facility to remove duplicates from the input rows.

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Jun 21st, 2012

By using BELOW SCENARIO we can do it the flow is like this
SRC-->SQ-->EXP-->T1
T2

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jun 11th, 2012

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.

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Jun 21st, 2012

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.

Utkarsh

• Mar 25th, 2012

1) Create Indexes on look up tables.
2) Try to use static cache instead of Dynamic cache.
3) Use Pushdown Optimization.

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

Hi,

We can capture the delta changes by using a look up transformation followed by an update strategy transformation with which can insert,delete and update records.

Thanks.

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

If we drop any sessions accidentally, it wont be deleted permanently until we do a check in. So if we want to recover the session, we can do a undo checkout on the session.

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jun 1st, 2007

If you dropped your session or folder we can get it back if it has proper backup.we can also get it back when you have same folders in other environment, I mean to say, generally, we will have th...

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

Hi, One way of getting only the duplicate columns loaded in the target table is to modify the SQ query: When primary keys are defined: select * from where exists (select PK1,PK2,... from group b...

koustav

• Jul 31st, 2007

I think you can write the sql query (delete from....) in session post-sql command and it will work good.

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 11th, 2012

When an Aggregator transformation is used without sorter, it stores all the data before performing the grouping operation. But when a sorter is used before aggregator, it sorts all the data before pas...

sai

• Feb 14th, 2007

passing data to sorter is time taking why because sorter transf stores whole data in buffer and then sorts based in specified ports.insted of passing data to sorter transf ,sort d data in the sours...

Answer Question  Select Best Answer

What is the structure of the reject file in Informatica?

Ramarao

• Jul 10th, 2012

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)

Kiran

• Apr 15th, 2012

There is no predefined structure for bad files. It has the same structure as of the target table.

Answer Question  Select Best Answer

jyothi

• Jul 24th, 2012

service oriented Architecture,Pushdown Optimization,sql t/r is added,java t/r is add

prashant

• Sep 3rd, 2011

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

Answer Question  Select Best Answer

Amit Gaikwad

• Jul 26th, 2012

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 .

nagadurgaraju

 Profile Answers by nagadurgaraju Questions by nagadurgaraju

• Sep 1st, 2010

By using source qualifier transformation to update tha target table,through SQL overriding...

Answer Question  Select Best Answer

If there are multiple source flat files with different names but same file structure. How do we load all those files to the target in one step?

Read Best Answer

Editorial / Best Answer

etluser  

 Profile Answers by etluser Questions by etluser

• Member Since Dec-2009 | Dec 31st, 2009

---

Follow the below steps-
1. Create the mapping as if there is only single source and target.
2. Now create an additional file on the server which will list the multiple source file names along with their paths.
3. Specify the path and name of this file in the "Source File" under session properties. 
4. Now the most important thing - Set "Source Filetype" as "indirect" under session properties.

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 3rd, 2012

There is a concept of Indirect filelist for processing multiple files with similar structure.

Rajath

• Feb 20th, 2012

What if there are n source files(number may vary) with the same structure? File name maybe similar for e.g. TxtFile_1,TxtFile_2,TxtFile_3...........TxtFile_n

Improve Answer

I have 2 sources one is relational table with 7 ports
second is flat file with 8 ports.How can I get the combined output and I should not do any modifications to the source structure?

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 3rd, 2012

Hi, I think we can obtain the results by using Joiner transformation. If the sources have no common columns, we can add one extra column with a value 1 in both the sources and then can join based on ...

Answer Question  Select Best Answer

MAHESH MANAM

• Aug 16th, 2012

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...

dileep671

 Profile Answers by dileep671 Questions by dileep671

• Aug 3rd, 2012

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.

Answer Question  Select Best Answer

Can we update target table without using update strategy transformation?

MAHESH MANAM

• Aug 22nd, 2012

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...

pranyarockvi

 Profile Answers by pranyarockvi Questions by pranyarockvi

• Jul 30th, 2012

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.

Answer Question  Select Best Answer

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 this?

MAHESH MANAM

• Sep 27th, 2012

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...

dileep671

 Profile Answers by dileep671 Questions by dileep671

• Jul 25th, 2012

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...

Answer Question  Select Best Answer

Hi All,I need to put the value of a col (request-id) in the text of the body of the post-session success/failure email which I have to send in Informatica. How to achieve this? We cannot, I guess, use a Parameter File for this as it would take the same value every time and put it in the email. I want to use the value of request-id which will be different on each session run and capture that value in...

kalyani.y

• Oct 9th, 2012

Create the EMAIL Task, in Properties Tab 1. EMAIL USER NAME : give the email id required 2. Subject as %w -- %e 3. Email Text as %g Session Start time : %b Session completion Time : %c Total Re...

rajeshmunikuntla

 Profile Answers by rajeshmunikuntla Questions by rajeshmunikuntla

• Jun 6th, 2011

Pls Help me,how to send email from informaticas Log file is the Requirement, i need log file as Email IN Box

Answer Question  Select Best Answer

narendraterainfo

 Profile Answers by narendraterainfo Questions by narendraterainfo

• Oct 14th, 2012

If the ETL is not ussing Full Pushdown optimization or Target Pushdown optimization . We can track with insert Time_stamp

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

We can track the changes in SCD type 2 in many ways:

--> A time column
--> Mentioning a version

Answer Question  Select Best Answer

Naveen

• Nov 8th, 2012

Set source file type as INDIRECT

Amit Gaikwad

• Jul 26th, 2012

Step 1: Transfer all the 5 files on to your UNIX box or server from where you will fetch those 5 files Step 2: open notepad and type the 5 files name .ex:- a.csv ...

Answer Question  Select Best Answer