IA virtual table

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
vamsi_4a6
Participant
Posts: 95
Joined: Wed Jun 04, 2014 12:06 am

IA virtual table

Post by vamsi_4a6 »

1)In IA we can define where clause for a table in Analysis setting for a particular project.We can also create a separate virtual table with where clause for table.what is the difference between these two?Pros and cons between these two things


2)Is it possible to perform column analysis after joining two tables?If so how?
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

Read up and try it yourself.
And remember to thank Ray for spoonfeeding you last time.
vamsi_4a6
Participant
Posts: 95
Joined: Wed Jun 04, 2014 12:06 am

Post by vamsi_4a6 »

I tried creating virtual table and i do not find any difference between these two and also I do not find any option to join two tables before doing column analysis
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can you be more specific about how to specify a WHERE clause when running an analysis? I cannot find it in version 8.5.0.3 and I cannot find it in version 11.3.1.2.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply