ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 12th, 2011

In Star schema, the data in the dimensional table is denormalized where as data in the Snow flake schema, it is normalized

ananta.prasad

 Profile Answers by ananta.prasad Questions by ananta.prasad

• May 3rd, 2008

In any schema fact table is in normalized form . it has reference keys to reference dimensional tables. Hence it is normalized

Answer Question  Select Best Answer

Narendra

• Sep 10th, 2011

Union will give duplicate records also. Main reason is it is derived from custom transformation when union used with custom transformation at that time it works as active transformation. if any transformation have active functionality definitely that transformation is active.

Thanks
@Nandu

mani

• Sep 8th, 2011

Union returns the distinct values when you merge the result set from 2 different tables.so duplicates are not allowed, so it is active transformation

Answer Question  Select Best Answer

malla reddy pannala

• Jul 25th, 2011

staging area is just like parking area before we entering the dwh here we doing here collecting the data from various data bases like oracle,db2, teradata to a single data base any of them, remove dup...

noverino

 Profile Answers by noverino Questions by noverino

• Feb 23rd, 2007

Staging area is temporary area used by ETL to do "Transformation" process. It could be anything, namely database, flat file, memory (cache), complex file, etc. In ETL, there's minimal 3 area: Source, Staging, Target (DW/DM).

Answer Question  Select Best Answer

If I have a source as below:Employeed, FamilyId, Contribution1,A,100002,A,200003,A,100004,B,205,B,20________________________________And my desired target is as below:EmployeeId,Contribution(In Percent)1,25%2,50%3,25%4,50%5,50% ____________________________________________________________________________Explanation: The contribution field in target is the individual Employee's share in a family's contribution.Say...

Mohan Krishna Bellamkonda

• Sep 7th, 2017

Code
 

Mohan Krishna Bellamkonda

• Sep 7th, 2017

Code
 

Answer Question  Select Best Answer

mani

• Sep 7th, 2011

Its n-1, so you need 9 transformations.

venkatesh

• Sep 7th, 2011

One joiner transformation

Answer Question  Select Best Answer

What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?

Read Best Answer

Editorial / Best Answer

sarun5  

 Profile Answers by sarun5 Questions by sarun5

• Member Since Feb-2008 | Mar 13th, 2008

---

Guys I have got the answer for which I asked..here you go

This can be handled by using the file list in informatica. If we have 5 files in different locations on the server and we need to load in to single target table. In session properties we need to change the file type as Indirect.
(Direct if the source file contains the source data. Choose Indirect if the source file contains a list of files.
When you select Indirect, the PowerCenter Server finds the file list then reads each listed file when it executes the session.)
am taking a notepad and giving following paths and file
names in this notepad and saving this notepad as
emp_source.txt in the directory /ftp_data/webrep/

/ftp_data/webrep/SrcFiles/abc.txt
/ftp_data/webrep/bcd.txt
/ftp_data/webrep/srcfilesforsessions/xyz.txt
/ftp_data/webrep/SrcFiles/uvw.txt
/ftp_data/webrep/pqr.txt

In session properties i give /ftp_data/webrep/ in the
directory path and file name as emp_source.txt and file type as Indirect.

Anurag

• Nov 27th, 2017

You should use a indirect file (which contain path and name of all the 5 files) as source. Transformation depends on the business logic.

Ashok Gulagond

• Dec 16th, 2016

When we have the same structured flat files, why don't simply use UNION make them a single file and then load to target instead of such complication? or UNION doesn't work on flat files?

Improve Answer

Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?

Read Best Answer

Editorial / Best Answer

ghola  

 Profile Answers by ghola Questions by ghola

• Member Since Jul-2008 | Aug 15th, 2008

---

The joiner transformation compares each row of the master source against the detail source. Hence, fewer number of rows in master means fewer iterations of join comparison.

Secondly It is easier to cache the table with fewer number of rows.

Hence, using the table having the fewer number of rows as a master improves the performance.

Raju R

• Oct 27th, 2015

@ponnana: The performance of the joiner depends on the rows and not on the columns. Also you take up the condition which consists n number of columns. Based on the condition the rows are obtained. So We need not worry about the columns.

Rashmi

• Oct 18th, 2015

The join is happening based on some condition. Therefore match process depends on the condition columns only and not how many columns are present in total. The table you drag into joiner first is considered as Master.

Improve Answer

How to load only the first and last record of a flat file into the target?

kishor Baindoor

• Jan 23rd, 2016

Connect source to two aggregator and then union it. In aggregator, if we donot check any column for aggregation then it will return last record by default. We can change this property in 2nd aggregator to return first record. When we union it we will get first and last record.

Raghav

• Apr 4th, 2015

Using rank and expression transformation.
More details at below link
http://www.raghavatal.com/2015/04/04/how-to-load-only-the-first-and-last-row-from-a-flat-file-to-a-target-file/

Answer Question  Select Best Answer

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 an Update Strategy transformation. Either input pipelines contains a connected or unconnected...

Tejas

• Jun 7th, 2019

We cannot use Update strategy in a pipeline when using joiner condition, because update strategy has property i.e treat row as which has insert,update,delete, which are processed at runtime, this limit joiner transformation to know exact properties values till runtime, and then proceed further.

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

We cannot use Joiner t/r immediately after sequence generator and upd strategy t/r as 1. Joiner will join 2 sources and it cannot join 3rd source as seq generator. Also if we select seq generator as 1...

Answer Question  Select Best Answer

srinivas.j.abinitio

 Profile Answers by srinivas.j.abinitio Questions by srinivas.j.abinitio

• Jul 1st, 2011

Hi ,Look up transformation does not replaces with using joiner transformation.because joiner return multiple matching values but look up can't return multiple matching values(look up policy multiple m...

xgeneration

 Profile Answers by xgeneration Questions by xgeneration

• May 25th, 2008

as u mensioned that a joiner transformation can be used to work out the functionality that of look-up using master outer join,but what if the source is from different database & source from dff da...

Answer Question  Select Best Answer

pkshve

 Profile Answers by pkshve Questions by pkshve

• Sep 13th, 2010

View is just a SQL statement stored in Database which is executed every single time its called.Materialized view (MV) is SQL statement and its resultant data stored in database in some form ...

Shekhar Pandit

• Sep 15th, 2006

DMLs can be used against view (if they are based on 1 table with no aggr funs)

Answer Question  Select Best Answer

sudeep

• Sep 18th, 2015

In general Fact table is normalized and Dimension table is denormalized. So that you will get all required information about the fact by joining the dimension in STAR schema. In some cases where dimensions are bulky then we we snowflake it and make it normailzed.

Niranjan

• Apr 23rd, 2015

Normalization is splitting 1 table to multiple tables to avoid insert/update and delete anomalies. They are done in OLTP systems. De-normalization is exact opposite of normalization, here multiple tab...

Answer Question  Select Best Answer

If 5 records are there in source, how will you make 10 in targets (double the number of records in source, duplicate source records)?

Anil

• Jun 22nd, 2016

We can do it by taking expression t/r and 2 instances of same target and connecting from same exp to 2 targets!

Anupam Kumar

• Apr 8th, 2016

Use Router. Create two group and just put TRUE in both

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

Hi,Can Informatica power center 7.1.1 installed on Windows vista home premium? If so how to install informatica server and repository server?Thank you,Vamshi.

anithashriya

 Profile Answers by anithashriya Questions by anithashriya

• Dec 22nd, 2007

But i could not find an option windows xp service pack 2 after right clicking on setup.exe of informatica powercenter 7.1.1, still the error is continuing if i try to execute setup.exe ...can anyone come up with the solution

Pallavi50953

 Profile Answers by Pallavi50953 Questions by Pallavi50953

• Dec 21st, 2007

Hi,   I installed informatica powercenter 7.1 in my laptop and i can even open repository server console.   But now for connecting to the repository it is asking for a password.Can any one specify which port and password should i specify for connecting to the repository.

Answer Question  Select Best Answer

Santosh

• Dec 26th, 2011

In Informatica 4 types of dimensions are available, these are 1) Degenerate dimensions 2) Junk dimesnsions ( a dimension which contains the less numbers of cordinality vales are less number of ind...

suren

• Nov 22nd, 2011

Hi Guys, Please don't answer wrong answers the above mentioned are Schema. , the dimension are discussed bellow. 1.Junk Dimension:Contains miscellaneous data such as flags and indicator 2.Degener...

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

Sharmila

• Mar 5th, 2016

We can validate all mappings at a time which are in a single folder level in Repository. Steps to follow: In power center Designer: Goto Tools => Queries 1. Create "New" Query in Query browser 2. Q...

swaroopkanth

• Feb 8th, 2012

We can validate all the mappings in the repository at once. This is possible through the repository manager.

Answer Question  Select Best Answer

It represents all data queried from the source.

Read Best Answer

Editorial / Best Answer

sprajarajan  

 Profile Answers by sprajarajan Questions by sprajarajan

• Member Since Mar-2008 | Aug 8th, 2008

---

Source Qualifier Is the default Transformation.
Through The source Qualifier Transformation Informatica Reads The Data.
We can Filter The Data.
We can sort the Data.
Its also Used to Join Homogeneous Source systems.
We can Join Any number of Sources in Singlae Source Qualifier.
We Can't Join the Flatfiles In sourcequalifier Because Flatfiles Are Heterogeneous When we open the Flatfiles At sourcequalifier At the time All The options are Disabled.

joyfun23

 Profile Answers by joyfun23 Questions by joyfun23

• Jan 26th, 2010

1. Source Qualifier is the most important transformation which convert the source data type in to compatible NATIVE datatype of a mapping.2. Without a SQ a mapping can not be created,?after extractio...

venkat224

 Profile Answers by venkat224 Questions by venkat224

• Dec 24th, 2009

Source Qualifier is one of the transformations, which converts any type of data to the relational format. So that, can easily be used for any of the operations on the data.

Improve Answer

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Jul 14th, 2014

Yes, We can!

Open the folder where the reusable transformation is existing.

Then open mapping designer then drag the reusable transformation to mapping designer area. Now hold the Ctrl key and drop it.

Now you have non reusable version of your reusable transformation.

Thanks

Bibhu

• Jul 4th, 2014

Yes, we can. It can be done in the transformation developer.

Answer Question  Select Best Answer