Can any one please tell me how to explain Data warehouse project in interview and from where to start and end. what to explain completely in it(data warehouse project), how much hast to explain from it(dw project) and what is architecture of it and data flow and construction of dw project or data warehouse.what is data warehouse methodology ,types of dw methodology, most using dw methodology in companies...

Could any body reply me, when the PowerExchange was first released in the market? Was it with Informatica 7.x versions? Please reply. Thank you.

Kumar.

Hi,

I have a requirement and I have created a mapping and I need to generate a single file based on location.

ex:
My server placed into us location and I will kick of my wf from uk so I need to create a uk file.

col1 col2 location
aaa bbb UK
xyz ccc UK

If I ran my wf from US location the out put file should be

How to find cumulative sum using JAVA Transformation?

Consider the following employees data as source

employee_id, salary
10, 1000
20, 2000
30, 3000
40, 5000

The target table data should look like as

employee_id, salary, cumulative_sum
10, 1000, 1000
20, 2000, 3000
30, 3000, 6000
40, 5000, 11000

Hi all! I am a fresh graduate in Nigeria, looking forward to working with one of the big fours soon as a member of the IT advisory team, what IT tools would you advice I get acquainted with while I work towards my recruitment, secondly, can someone please enlighten me on the areas of ERP I need to take interest in, in order to perform on the job?

Can anybody plz explain what would be the daily routine and reporting hierarchy of an ETL developer in sales project...

I have oracle 9i and windows XP installed on my machine and try to install informatica 8.6 and after successfully installing client and server try to do all setting in Power Center Administration Console and create new repository but repository services are not up and giving error that Unable to connect to the repository Repo on database TEST.

TEST is the SID on my machine

Hi

My name is amit and i am here to take some career advice.

I did Bsc (H) CS from delhi university in 2009 and after it i joined a company where my profile was Analyst in Excel and some basic use of SQL query. I worked there almost 3.8 yrs but due to some personal reasons i quit my job on september 2013 and now i am idle for last 4 months.

Now i wants to switch...

How to check if the Informatica Power Center is highly available?

How often do you get Add/modify column changes in Facts and dimensions?

Could you please give me couple real time Datawarehouse Project specific (Day to day work) scenarios?

Could not execute action...

The Service Name_repository could not be enabled due to the following error: OBJM_54538 - Unable to connect to the repository Name_repository on database mailto:DESKTOP-4FVDDK@IPC.error: OBJM_54538

Please could you help me with this issue?

Static cache Dynamic cache U can not insert or update the cacheU can insert rows into the cache as u pass to the target The informatic server returns a value from the lookup table or cache when the condition is true.When the condition is not true, informatica server returns the default value for connected transformations and null for unconnected transformations.The informatic server inserts rows into...

vp

• Mar 6th, 2006

lets say for example your lookup table is your target table. So when you create the Lookup selecting the dynamic cache what It does is it will lookup values and if there is no match it will insert th...

Answer Question  Select Best Answer

When the informatica server runs in the ASCII data movement mode it sorts session data using Binary sortorder.If U configure the seeion to use a binary sort order,the informatica server caluculates the binary value of each string and returns the specified number of rows with the higest binary values for the string.

phani

• Dec 9th, 2005

When Informatica Server runs in UNICODE data movement mode ,then it uses the sort order  configured in session properties.

Answer Question  Select Best Answer

The Designer automatically creates a RANKINDEX port for each Rank transformation. The Informatica Server uses the Rank Index port to store the ranking position for each record in a group. For example, if you create a Rank transformation that ranks the top 5 salespersons for each quarter, the rank index numbers the salespeople from 1 to 5:

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 12th, 2006

Based on which port you want generate Rank is known as rank port, the generated values are known as rank index.Cheers,Sithu

Answer Question  Select Best Answer

Join data originating from same source data base. Filter records when the informatica server reads source data. Specify an outer join rather than the default inner join specify sorted records. Select only distinct values from the source. Creating custom query to issue a special SELECT statement for the informatica server to read source data.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 24th, 2006

Join data originating from the same source database. You can join two or more tables with primary-foreign key relationships by linking the sources to one Source Qualifier. Filter records when the Info...

Answer Question  Select Best Answer

U specify the target loadorder based on source qualifiers in a maping.If u have the multiple source qualifiers connected to the multiple targets,U can designatethe order in which informatica server loads data into the targets.

saritha

• Mar 1st, 2006

A target load order group is the collection of source qualifiers, transformations, and targets linked together in a mapping.

Answer Question  Select Best Answer

Simple Pass through maping : Loads a static fact or dimension table by inserting all rows. Use this mapping when you want to drop all existing data from your table before loading new data. Slowly Growing target : Loads a slowly growing fact or dimension table by inserting new rows. Use this mapping to load new data when existing data does not require updates.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

1. Simple Pass through2. Slowly Growing TargetCheers,Sithu

Answer Question  Select Best Answer

Type2 Dimension/Version Data Maping: In this maping the updated dimension in the source will gets inserted in target along with a new version number.And newly added dimension in source will inserted into target with a primary key. Type2 Dimension/Flag current Maping: This maping is also used for slowly changing dimensions.In addition it creates a flag value for changed or new dimension. Flag indiactes...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 4th, 2006

Type21. Version number2. Flag3.DateCheers,Sithu

Answer Question  Select Best Answer

Partitioning achieves the session performance by reducing the time period of reading the source and loading the data into target.

khadarbasha

 Profile Answers by khadarbasha Questions by khadarbasha

• Sep 30th, 2005

Performance can be improved by processing data in parallel in a single session by creating multiple partitions of the pipeline.Informatica server can achieve high performance by partitioning the pipleline and performing the extract , transformation, and load for each partition in parallel. 

Answer Question  Select Best Answer

For a relational sources informatica server creates multiple connections for each parttion of a single source and extracts seperate range of data for each connection.Informatica server reads multiple partitions of a single source concurently.Similarly for loading also informatica server creates multiple connections to the target and loads partitions of data concurently. For XML and file sources,informatica...

durga

• Feb 13th, 2006

Fine explanation

Answer Question  Select Best Answer