Answer / swetha

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.

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,

---

how to we create datamart?

2 Answers   HSBC,

---

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

0 Answers   Patni,

---

What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  

---

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

---

What is the Difference between sorter and aggregator?

2 Answers  

---

When you move from devel to prod how will you retain a variable

1 Answers  

---

Why is meant by direct and indirect loading options in sessions?

4 Answers  

---

can u any challenge your project?

0 Answers   HP,

---

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...

4 Answers   Keane India Ltd,

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---