Prasad

• Jul 14th, 2006

what ever is said above is correct. Just add 2 dummy ports in the joiner transformation with the same datatypes(Integer). one dummy port as detail and other as master.Then assign both the ports d...

kumar

• Jun 11th, 2006

Could you please briefly explain on this?

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

hi,u can start from the 3rd session by right clicking on that session and select "start workflow from this task".This will ensure that the workflow has started to run from 3rd session and continues till the last one.

windows

 Profile Answers by windows Questions by windows

• May 23rd, 2006

If multiple sessions in a concurrent batch fail, you might want to truncate all targets and run the batch again. However, if a session in a concurrent batch fails and the rest of the sessions complete...

Answer Question  Select Best Answer

abc

• Jul 14th, 2006

By using command task.

Answer Question  Select Best Answer

Sridhar.B

• Jul 12th, 2006

The "Slowly Changing Dimension" problem is a common one particular to data warehousing. In a nutshell, this applies to cases where the attribute for a record varies over time. We give an example below...

priyamayee

 Profile Answers by priyamayee Questions by priyamayee

• Jun 8th, 2006

Hii, It depends on the business requirement u have. We use this SCD's to maintain history(changes/updates) in the dimensions. Each SCD type has it's own way of storing/updating/maintaining the history...

Answer Question  Select Best Answer

bala

• Jul 6th, 2006

Hi,   Informatica is a ETL tool.used for the Extraction,Transformation and Loadind of data.This tool is used to Extract the data from different Data Bases and then we can do the required tra...

Answer Question  Select Best Answer

Shanmugam

• Jul 6th, 2006

To optimize the aggregator transformation, you can use the following options.Use incremental aggregationSort the ports before you perform aggregationAvoid using aggregator transformation after update strategy, since it might be confusing.

Guru

• May 25th, 2006

T1 and T3 are being the master table and don't have any foreign key refrence to other table will be loaded first. Then T3 will be loaded as it's master table T3 is already been loaded. ...

Answer Question  Select Best Answer

Motilal

• Jun 30th, 2006

Ya its the level of information storage in session log.The option comes in the properties tab of transformations. By default it remains "Normal". Can be Verbose InitialisationVerbose DataNormal or Terse.

rajesh

• Jun 21st, 2006

Tracing level determines the amount of information that informatcia server writes in a session log.

Answer Question  Select Best Answer

Motilal

 Profile Answers by Motilal Questions by Motilal

• Jun 30th, 2006

Yep! the answer provided is absolutely right. by an SQL application(Oracle).If you want to perform it thru informatica, the Fire the same query in the SQL Override of Source qualifier transformation a...

gh

• Jun 20th, 2006

Select count(*),deptno from dept group by deptno having count(*) >=10;

Answer Question  Select Best Answer

I am getting installation problems while trying to install Informatica 6.1It says that PmRepServer service should be installed.Any suggestions should be appreciated

Motilal

• Jun 30th, 2006

You need to check the repository server, informatica server and client while installing. Meta data and ODBC are optional.Then while installing, the user name needed to be given same as the O.S usernam...

reddy

• May 8th, 2006

when iam trying to install the s/w..it says PmRepserver needs to started...i had tried it many waysplzz help me in this regardany suggestions are apprecaited.

Answer Question  Select Best Answer

I am asked to create a detailed metadata about ,transformations used in particular fact table mapping.How do i understand and create write up on what has happened to each port during each transformations?By right click on port in target definition and choosing backward path , I could get complete path for that port.Pls. adviseThanks,

motilal

• Jun 30th, 2006

you need to do it manually.In some cases you can see the effects by firing SQL queries in database directly.You may also use debugger to see the path followed if u have the privillege.But The best way is analyse and write the metadata manually.

Answer Question  Select Best Answer

reddy

• Jun 29th, 2006

You have to use two joiner transformations.fIRST one will join two tables and the next one will join the third with the resultant of the first joiner.

sandeep

• Jun 24th, 2006

hi using join transformation

Answer Question  Select Best Answer

If u parttion a session with a relational target informatica server creates multiple connections to the target database to write target data concurently.If u partition a session with a file target the informatica server creates one target file for each partition.U can configure session properties to merge these target files.

kareemuddin ahmed

• Jun 24th, 2006

Could you please tell me how can we partition the session and target?

UmaBojja

• Jun 13th, 2006

Partition's can be done on both relational and flat files.Informatica supports following partitions1.Database partitioning2.RoundRobin3.Pass-through4.Hash-Key partitioning5.Key Range partitioningAll t...

Answer Question  Select Best Answer

mootati raghavendroa reddy

• Jun 23rd, 2006

To eliminate the duplicate in flatfiles, we have distinct property in sorter transformation. If we enable that property, automatically it will remove duplicate rows in flatfiles.

sai

• Jun 13th, 2006

Hiusing Sorter Transformation we can eliminate the Duplicate Rows from Flat fileThanksN.Sai

Answer Question  Select Best Answer

Uma Bojja

 Profile Answers by Uma Bojja Questions by Uma Bojja

• Jun 16th, 2006

Data can be viewed using Informatica's designer tool.If you want to view the data on source/target we can preview the data but with some limitations.We can use data profiling too.ThanksUma 

Answer Question  Select Best Answer

karthikeyansp2003

 Profile Answers by karthikeyansp2003 Questions by karthikeyansp2003

• Jun 15th, 2006

In hash partitioning, the Informatica Server uses a hash function to group rows of data among partitions. The Informatica Server groups the data based on a partition key.Use hash partitioning when you...

windows

 Profile Answers by windows Questions by windows

• Jun 1st, 2006

When you want the Informatica Server to distribute rows to the partitions by group.

Answer Question  Select Best Answer

UmaBojja

• Jun 13th, 2006

In the designer go to the main menu and one can see the export/import options.Import the exported mapping in to the production repository with replace options.ThanksUma

Answer Question  Select Best Answer

priyamayee

 Profile Answers by priyamayee Questions by priyamayee

• Jun 8th, 2006

Hii, have u impleted using wizards???? If so, create the target with the name u have given in wizard for target(table). No't create the target again for the second instance. It is just the virtual cop...

Answer Question  Select Best Answer

Krishna Ramineni

• Jun 6th, 2006

You can overide the sql Query in Wofkflow Manager. LIkeselect * from tab_name where rownum<=1000minusselect * from tab_name where rownum<=500;This will work fine. Try it and get back to me if u have any issues about the same.

viswanath

• May 26th, 2006

in db2 we write statement as fetch first 500 rows only.in informatica we can do by using sequence generator and filter out the row when exceds 500

Answer Question  Select Best Answer

srinu

• May 27th, 2006

We can check also line sequntial buffer insted of 1024 byes,we vcann add some more bytes of data

Uma Bojja

• May 3rd, 2006

1.File is fixed width or delimited2.Size of the file.If its can be executed without performance issues then normal load will workIf its huge in GB they NWAY partitions can be specified at the source side and the target side.3.File reader,source file name etc .....

Answer Question  Select Best Answer